HCL Notes and Domino wiki: Lotus Notes: Make a Notes mailing list (or group) from contacts in an Excel spreadsheet

Make a Notes mailing list (or group) from contacts in an Excel spreadsheet

Added by ~Julia Breresonakoi | Edited by ~Julia Breresonakoi on March 8, 2011 | Version 8

Actions ▼

If you have a bunch of contacts in Excel, and you'd like to create a group (which is the same as a mailing list) out of them in Notes, here is how you do it.

Tags: contacts, group, excel, mailing list, import, export, moving_contacts, distribution list

(I got this question over email, so I thought I'd share the answer here)

With the Excel file open, click Save as, and save the file as a vCard (.vcf) file.
Open Contacts, select File > Import, and open the vCard file. Finish importing the contacts.
After importing, select all the contacts you would like to put in the mailing list, and then click More > Copy into new Group.
Name the group and save it.
Whenever you want to email the group, type the group name in the To field, and you should be all set.